## cmte_id cand_id cand_nm
## C00431445:15243 P80003338:15243 Obama, Barack:15243
##
##
##
##
##
##
## contbr_nm contbr_city contbr_st
## KHV, KHV : 110 HONOLULU :6558 HI:15243
## HOUSTON, PATRICIA: 76 KAILUA :1202
## MURAKAMI, ROBERT : 61 HILO : 611
## YAMANOHA, LYN : 60 KANEOHE : 586
## SULTAN, A A : 58 KAMUELA : 517
## TYLER, CLARK : 58 KAILUA KONA: 435
## (Other) :14820 (Other) :5334
## contbr_zip contbr_employer contbr_occupation
## Min. : 0 NOT EMPLOYED :3738 RETIRED : 3403
## 1st Qu.:967343212 SELF EMPLOYED :2842 ATTORNEY : 620
## Median :967688422 UNIVERSITY OF HAWAII : 452 NOT EMPLOYED: 477
## Mean :882254074 INFORMATION REQUESTED: 325 PROFESSOR : 350
## 3rd Qu.:968165550 : 318 TEACHER : 340
## Max. :968480001 (Other) :7531 (Other) :10021
## NA's :3 NA's : 37 NA's : 32
## contb_receipt_amt contb_receipt_dt
## Min. :-4600.0 16-Oct-08: 313
## 1st Qu.: 25.0 30-Sep-08: 313
## Median : 75.0 27-Aug-08: 299
## Mean : 203.6 31-Jul-08: 282
## 3rd Qu.: 125.0 24-Oct-08: 281
## Max. : 4600.0 31-Oct-08: 238
## NA's :35 (Other) :13517
## receipt_desc memo_cd
## :14424 :14165
## REATTRIBUTION/REDESIGNATION REQUESTED: 266 X: 1078
## REDESIGNATION FROM : 252
## REDESIGNATION TO : 248
## Refund : 38
## REATTRIBUTION FROM : 5
## (Other) : 10
## memo_text form_tp
## :13040 : 35
## OVF TRANSFER : 1054 SA17A:14100
## REATTRIBUTION/REDESIGNATION REQUESTED: 266 SA18 : 1070
## ORIGINAL TRANSACTION : 256 SB28A: 38
## REDESIGNATION FROM : 252
## REDESIGNATION TO : 248
## (Other) : 127
## file_num tran_id election_tp
## Min. :359390 : 35 : 35
## 1st Qu.:753671 2299577 : 2 G2008:6418
## Median :753769 2299577RMIN: 2 P2008:8790
## Mean :658074 10000818 : 1
## 3rd Qu.:753821 10001490 : 1
## Max. :754317 10001522 : 1
## NA's :35 (Other) :15201
My report explores the 2008 Presidential Campagin Finance dataset containing data about financial support to president Barack Obama, in his native state, Hawaii.
The majority of countributors come from Honolulu, followed by Kailua and Hilo.
I create a new category ‘County’ and I see that most contributors come from Honolulu county.
Most of the contributions are around 100, with 50% of the contributions greater than 75.
The primary election had received more contributions than the general.
My dataset has 15243 observations and 18 variables. The most relevant variables for my report are: - contbr_nm: the contributer’s name - contbr_city: the contributer’s city - contb_receipt_amt: the amount - contbr_occupation - contbr_employer - election_tp: election type
I would like to see the received financial support by looking at contributor’s location, so I choose two counties to explore: Honolulu and Hawaii. The variables used are contbr_city contb_receipt_amt and contbr_occupation.
I will use election_tp to compare the data between the two election types.
I created new categories for county, employer and occupation.
## $title
## [1] "Contribution amount by county"
##
## attr(,"class")
## [1] "labels"
Due to their contrast, I chose to focus on 2 different counties: Honolulu and Hawaii.
## RETIRED DRAFTING SERVICE
## 255 59
## PROFESSOR NOT EMPLOYED
## 47 45
## TEACHER
## 42 35
## SCHOOL ADMINISTRATOR BUILDER
## 23 22
## COFFEE ROASTER SOFTWARE ENGINEER
## 19 19
## INNKEEPER AND COUNSELOR ATTORNEY
## 18 17
## FINANCIAL SOFTWARE CONSULTANT INNKEEPER/COUNSELOR
## 17 17
## TELESCOPE SYSTERM SPEC INFORMATION REQUESTED
## 17 15
## OFFICE ADM. PHYSICIAN
## 13 13
## ARCHITECT COMPUTER PROGRAMMER
## 12 12
## OWNER INNKEEPER
## 12 11
## SALES ARCHITECT, FARMER
## 11 10
## COMPUTER/IS ADMINISTRATOR BUILDING CONTRACTOR
## 10 9
## FACTORY PERSONAL ASSISTANT
## 9 9
## CHILD CARE PROVIDER COUNSELOR
## 8 8
## FINANCIAL SOFTWARE CONSLT. MD
## 8 8
## TEACHER/ADMINISTRATOR ASTRONOMER
## 8 7
## CONSULTANT ENGLISH INSTRUCTOR
## 7 7
## INN INNKEEPER-OWNER
## 7 7
## MENTAL HEALTH THERAPIST MERCHANT
## 7 7
## WHOLESALE PRODUCE ARTIST
## 7 6
## EDUCATOR PROJECT MANAGER
## 6 6
## PUBLISHER WHOLESALER/EXPORTER
## 6 6
## FINANCIAL CONSULTANT WHOLESALER
## 5 5
## WRITER ARCHITECHT
## 5 4
## COFFEE FARMER COLLEGE ADMINISTRATOR
## 4 4
## COMPUTER CONSULTANT EXECUTIVE DIRECTOR
## 4 4
## INNKEEPOER LECTURER
## 4 4
## PEDIATRICIAN PHOTOGRAPHER
## 4 4
## PROF PROJECT ENGINEER
## 4 4
## TAX ACCOUNTANT THERAPIST
## 4 4
## ACCOUNT CLERK ACCOUNTING CLERK
## 3 3
## BOOKKEEPER BRANCH MANAGER
## 3 3
## CLERK TYPIST II CLINICAL SOCIAL WORK
## 3 3
## CONSTRUCTION INSPECTOR ENGINEER
## 3 3
## ENTOMOLOGIST FARMER, ATTORNEY, INVESTOR
## 3 3
## GENERAL CONTRACTOR INSTRUCTOR
## 3 3
## KINDERGARTEN TEACHER MACINTOSH TECHNICIAN
## 3 3
## MEDICAL DOCTOR NURSE
## 3 3
## PROPERTY MANAGER REAL ESTATE SALES
## 3 3
## RN SCIENTIST
## 3 3
## VACATION RENTAL OWNER WRITER/EDITOR
## 3 3
## WRITER/EDUCATOR/COUNSELOR 650 IWILEI ROAD, HONOLULU, HI 96817
## 3 2
## ASSISTANT PROFESSOR COLLEGE INSTRUCTOR
## 2 2
## HANDYMAN MANAGER
## 2 2
## PHYSICIAN-DISABLED PILOT
## 2 2
## PRESIDENT PROFESSOR OF BIOLOGY
## 2 2
## PUBLIC RELATIONS SPECIALIST REGIONAL DIRECTOR
## 2 2
## REGISTERED NURSE RESEARCH ASSOCIATE
## 2 2
## RESEARCH ECOLOGIST (Other)
## 2 34
## RETIRED ATTORNEY
## 2073 530
## PROFESSOR PHYSICIAN
## 276 234
## NOT EMPLOYED TEACHER
## 232 230
## PRESIDENT
## 205 189
## INFORMATION REQUESTED HOMEMAKER
## 160 155
## CONSULTANT MANAGER
## 114 101
## LAWYER ASTRONOMER
## 69 64
## WRITER PSYCHOLOGIST
## 63 61
## REALTOR SOFTWARE ENGINEER
## 60 59
## RESEARCHER HEALTH CARE
## 56 52
## ARCHITECT COST ESTIMATOR
## 47 47
## ACCOUNTANT ARTIST
## 44 44
## OWNER LAW
## 43 41
## EWO CEO
## 40 36
## SALES PLANNER
## 36 35
## RN STUDENT
## 35 35
## SOCIAL WORKER BOOKSELLER
## 34 32
## ENGINEER MEDIATOR
## 32 32
## SMALL BUSINESS OWNER EDITOR
## 31 30
## ASSISTANT PROFESSOR EDUCATOR
## 29 29
## REAL ESTATE U.S. MARINES
## 29 28
## SPEECH PATHOLOGIST RESEARCH ASSISTANT
## 27 26
## TAX PREPARER ADMINISTRATOR
## 26 25
## INFORMATION SYSTEMS SECURITY MINISTER/PROFESSIONAL MUSICIAN
## 25 25
## MUSIC HOST PARALEGAL
## 25 25
## REAL ESTATE BROKER COMPUTER PROGRAMMER
## 25 24
## EXECUTIVE MECHANIC
## 24 24
## MEDIA PHOTO JOURNALIST
## 24 24
## ADMIN MANAGER INDEPENDENT ASSOCIATE
## 23 23
## INVESTOR MARKETING
## 23 23
## GENERAL MANAGER PROGRAM MANAGER
## 22 21
## REAL ESTATE DEVELOPER ACADEMIC COORDINATOR
## 21 20
## SENIOR FORECASTER WRITER/PRODUCER
## 20 20
## FLIGHT ATTENDANT NURSE
## 19 19
## OFFICER REFUSED
## 19 19
## BANKER SALES/MARKETING/OWNER
## 18 18
## ADMIN. MANAGER ART DIRECTOR
## 17 17
## DOCUMENTARY FILMMAKER ENGLISH PROFESSOR
## 17 17
## ENVIRONMENTAL CONSULTANT INVESTIGATOR
## 17 17
## SELF VACATION RENTAL
## 17 17
## ANALYST GEOSPATIAL INFORMATION TECHNOLOGIST
## 16 16
## PILOT SECRETARY
## 16 16
## SUBSTITUTE TEACHER AIR TRAFFIC CONTROL SPECIALIST
## 16 15
## AIR TRAFFIC CONTROLLER CLERICAL
## 15 15
## CPA DIRECTOR
## 15 15
## GRADUATE ASSISTANT PEDIATRICIAN
## 15 15
## REGISTERED NURSE REGISTRAR
## 15 15
## ADMINISTRATIVE DIRECTIOR CEO AND OWNER
## 14 14
## EDUCATION ADMINISTRATION GRAPHIC ARTIST
## 14 14
## (Other) NA's
## 2440 21
Running a summary for the occupation type, I see that for Hawaii county the top 5 most present are Retired, Drafting service, Professor, Not Employed and Teacher. While for Honolulu are: Retired, Attorney, Professor, Physician and Not Employed.
Further I will explore the data looking at these professions in particular.
For both counties and in most cities, Retired group are the highest contributors. In Hawaii county this is followed by Drafting service and in Honolulu by Attorney.
The primary election has a higher percentage of contributions. For Hawaii county there is a higher percentage for the general election for 250 amount.
The countribution amount varies in relation to location: cities with higher population (Hilo, Honolulu) have more contributers and I was expected that.
There is a strong relation between contb_receipt_am and election_tp: the primary election has a higher percentage of small amounts.
Although I knew that Hawaii is the favorite place of retirment for many, I was surprised to see this group so strong in larger cities(Hilo, Honolulu) and such a strong relation between contbr_occupation and contb_receipt_amt.
Most of the contributions are amount of 75 and 100. for Honolulu county 25% of contributions are over 200 while for Hawaii are 100.
Looking at the most loyal financial supporters, by subsetting the data for individuals making over 20 contributions, I found that the two counties have in common three occupations: retired as the largest, followed by not-employed and professor.
Looking at the most generous contributions, these come from Honolulu county. For Hawaii county, they are part of the retired group and come from Captain Cook city - which is not one of the largest cities.